SUPPORT / SAMPLES & SAS NOTES
Problem Note 67758: Trying to access a Google BigQuery external table might result in an error
 |  |  |  |  |
Trying to access a Google BigQuery external table might result in an error if you are running SAS® 9.4M6 (TS1M6) with Hot Fix H5A005 or H5A006 or with SAS® Viya® 2020.1.4. Here are some situations that might cause this issue to occur:
- Trying to open the table using SAS® Studio Library Explorer.
- Trying to run code against the table using one of the following:
- SET statement in a DATA step
- running the CONTENTS procedure when using the SCANSTRINGCOLUMNS LIBNAME or data set option
- running the SQL procedure with a SELECT * statement
The error that occurs might vary depending on exactly what you are doing and whether you are using SCANSTRINGCOLUMNS=YES LIBNAME or data set option. Some of the errors that have been seen are the following:
Trying to open the external table in SAS Studio Library Explorer generates a pop-up window with the following error:
No data was returned for table xxx. To try again, check your filter and column selection, change the preferences that determine the number of rows and columns that are displayed or refresh the table.
Trying to run code against the external table might result in an error similar to the following:
ERROR: CLI cursor extended fetch error: Error: googleapi: Error 400: Cannot list a table of type EXTERNAL., invalid
The workaround, in some cases for code, is to use the FEDSQL procedure instead.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.41 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.05 | 2020.1.5 | Viya | Viya |